USE [TBbilling]
GO
/****** Object:  Table [dbo].[NewDemographics]    Script Date: 02/06/2015 15:43:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NewDemographics](
	[BillID] [int] NULL,
	[episodeID] [int] NULL,
	[transaction_Date] [datetime2](7) NULL
) ON [PRIMARY]
GO


USE [TBbilling]
GO
/****** Object:  Table [dbo].[PatientTransfer]    Script Date: 02/06/2015 15:43:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PatientTransfer](
	[billID] [int] NULL,
	[episodeid] [int] NULL,
	[transaction_Date] [datetime2](7) NULL
) ON [PRIMARY]
GO


USE [TBbilling]
GO
/****** Object:  Table [dbo].[TransferAudit]    Script Date: 02/06/2015 15:43:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TransferAudit](
	[transferAuditID] [int] IDENTITY(1,1) NOT NULL,
	[transferStartDate] [datetime] NULL,
	[transferEndDate] [datetime] NULL,
	[processStartDate] [datetime] NULL,
	[processEndDate] [datetime] NULL
) ON [PRIMARY]
GO

